![]() |
![]() |
![]() |
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() |
![]() |
To access the contents, click the chapter and section titles.
Oracle Performance Tuning and Optimization
Threshold MonitorsThreshold monitoring tools remain quiescent until some sort of condition requires an alert. These conditions are usually an indication that an event (such as a tablespace filling up) has occurred or that some sort of failure needs attention. Threshold monitors typically work on a sampling interval; for some events, they may insert into the database itself triggers that are fired when some sort of event occurs. You should set the time interval for sampling on a per-event basis. If there is a critical event, you may want to shorten the sampling interval. In general, the longer the sampling interval, the less effect there is on the systems performance. Many of the threshold monitors available today can monitor a variety of RDBMS products and applications as well as a variety of different operating systems. In a large installation, it can be valuable to monitor all your systems from one console, regardless of what OS and products the system is running. If your RDBMS system performs a mission-critical task, it may be imperative that you employ a threshold monitoring program. The most sophisticated of these tools have options that give alerts in several forms, including graphical display, e-mail, and even paging. This type of monitor may be able to alert you in advance of a problem, allowing you to correct the problem and avoid downtime. SummaryThis chapter gave you a brief introduction to performance monitoring tools. Whether you use third-party tools or the tools Oracle provides in combination with the tools that come with your operating system, it is important to monitor your system regularly. When you implement your configuration, it is important to monitor the system during the development and tuning phases. It is equally important to monitor your system on a regular basis. The worst type of problem is one you are not expecting and are not prepared for. Monitoring tools that monitor both RDBMS and OS parameters and alert you in the event of a problem are very useful. These tools can help you find problems before they occur and can help you avoid costly downtime. If your system is used in a mission-critical application, the time spent recovering from a failure can be devastating; monitoring such systems is imperative. If you want to use a third-party monitoring tool, choose one that has the functionality you need for your particular installation. Consider getting a monitoring tool that monitors both the OS and Oracle. Finally, make sure that the performance monitor does not adversely affect the performance of your system. By choosing the right performance monitor, you should be able to assess changes made to your system as well as monitor the day-to-day health of the system. Be sure to monitor your system periodically even if everything seems fine. By checking the health of the system regularly, you may be able to catch small problems before they become big ones.
|
![]() |
Products | Contact Us | About Us | Privacy | Ad Info | Home
Use of this site is subject to certain Terms & Conditions, Copyright © 1996-2000 EarthWeb Inc. All rights reserved. Reproduction whole or in part in any form or medium without express written permission of EarthWeb is prohibited. |